package com.web22_2_1.mapper;

public class StudentSQL {
    public static final String SELECT_ALL_STUDENTS = "SELECT * FROM students";
    public static final String SELECT_STUDENT_BY_ID = "SELECT * FROM students WHERE StudentID=?";
    public static final String SELECT_STUDENT_BY_NAME = "SELECT * FROM students WHERE Name=?";
    public static final String INSERT_STUDENT = "INSERT INTO students(UserId,Name,Gender,BirthDate,Address,Phone,Email) VALUES(?,?,?,?,?,?,?)";
}
